Supported Functionality

The following tables list functionality supported for each JDBC object.

Array Object

Array Object
Methods
Version
Introduced
Supported
Comments
(all)
2.0 Core
No
Array objects are neither exposed, nor taken as input.

Blob Object

Blob Object  
Methods
Version
Introduced
Supported
Comments
InputStream getBinaryStream ()
2.0 Core
Yes
 
byte[] getBytes (long, int)
2.0 Core
Yes
 
long length ()
2.0 Core
Yes
 
long position (byte, long)
2.0 Core
Yes
 
long position (Blob, long)
2.0 Core
Yes
 
OutputStream setBinaryStream (long)
3.0 Core
Yes
 
int setBytes (long, byte[])
3.0 Core
Yes
 
int setBytes (long, byte[], int, int)
3.0 Core
Yes
 
void truncate (long)
3.0 Core
Yes
 
NOTE: Blob support is emulated using LONGVARBINARY datatypes on SQL Server, Sybase, JDBC Socket, and ODBC Socket. Using emulated Blobs incurs a performance and scalability penalty.

CallableStatement Object

CallableStatement Object  
Methods
Version
Introduced
Supported
Comments
Array getArray (int)
2.0 Core
No
Throws "unsupported method" exception.
Array getArray (String)
3.0
No
Throws "unsupported method" exception.
BigDecimal getBigDecimal (int)
2.0 Core
Yes
 
BigDecimal getBigDecimal (int, int)
1.0
Yes
 
BigDecimal getBigDecimal (String)
3.0
No
Throws "unsupported method" exception.
Blob getBlob (int)
2.0 Core
Yes
Not supported on servers which emulate this functionality over LONGVARBINARY.
Blob getBlob (String)
3.0
No
Throws "unsupported method" exception.
boolean execute ()
1.0
Yes
 
boolean execute (String)
1.0
No
Throws "invalid method call" exception.
boolean execute (String, int)
3.0
No
Throws "invalid method call" exception.
boolean execute (String, int[])
3.0
No
Throws "invalid method call" exception.
boolean execute (String, String[])
3.0
No
Throws "invalid method call" exception.
boolean getBoolean (int)
1.0
Yes
 
boolean getBoolean (String)
3.0
No
Throws "unsupported method" exception.
boolean getMoreResults ()
1.0
Yes
 
boolean getMoreResults (int)
3.0
Yes
Not supported on Informix.
boolean wasNull ()
1.0
Yes
 
byte [] getBytes (int)
1.0
Yes
 
byte [] getBytes (String)
3.0
No
Throws "unsupported method" exception.
byte getByte (int)
1.0
Yes
 
byte getByte (String)
3.0
No
Throws "unsupported method" exception.
Clob getClob (int)
2.0 Core
Yes
Not supported on servers which emulate this functionality over LONGVARCHAR.
Clob getClob (String)
3.0
No
Throws "unsupported method" exception.
Connection getConnection ()
2.0 Core
Yes
 
Date getDate (int)
1.0
Yes
 
Date getDate (int, Calendar)
2.0 Core
Yes
 
Date getDate (String)
3.0
No
Throws "unsupported method" exception.
Date getDate (String, Calendar)
3.0
No
Throws "unsupported method" exception.
double getDouble (int)
1.0
Yes
 
double getDouble (String)
3.0
No
Throws "unsupported method" exception.
float getFloat (int)
1.0
Yes
 
float getFloat (String)
3.0
No
Throws "unsupported method" exception.
int [] executeBatch ()
2.0 Core
Yes
 
int executeUpdate ()
1.0
Yes
 
int executeUpdate (String)
1.0
No
Throws "invalid method call" exception.
int executeUpdate (String, int)
3.0
No
Throws "invalid method call" exception.
int executeUpdate (String, int[])
3.0
No
Throws "invalid method call" exception.
int executeUpdate (String, String[])
3.0
No
Throws "invalid method call" exception.
int getFetchDirection ()
2.0 Core
Yes
 
int getFetchSize ()
2.0 Core
Yes
 
int getInt (int)
1.0
Yes
 
int getInt (String)
3.0
No
Throws "unsupported method" exception.
int getMaxFieldSize ()
1.0
Yes
 
int getMaxRows ()
1.0
Yes
 
int getQueryTimeout ()
1.0
Yes
Returns 0 for DB2 and Informix.
int getResultSetConcurrency ()
2.0 Core
Yes
 
int getResultSetHoldability ()
3.0
No
Throws "unsupported method" exception.
int getResultSetType ()
2.0 Core
Yes
 
int getUpdateCount ()
1.0
Yes
 
long getLong (int)
1.0
Yes
 
long getLong (String)
3.0
No
Throws "unsupported method" exception.
Object getObject (int)
1.0
Yes
 
Object getObject (int, Map)
2.0 Core
Yes
Map ignored.
Object getObject (String)
3.0
No
Throws "unsupported method" exception.
Object getObject (String, Map)
3.0
No
Throws "unsupported method" exception.
ParameterMetaData getParameterMetaData()
3.0
Yes
Not supported on Oracle or Informix Servers.
Ref getRef (int)
2.0 Core
No
Throws "unsupported method" exception.
Ref getRef (String)
3.0
No
Throws "unsupported method" exception.
ResultSet executeQuery ()
1.0
Yes
 
ResultSet executeQuery (String)
1.0
No
Throws "invalid method call" exception.
ResultSet getGeneratedKeys()
3.0
No
Throws "unsupported method" exception.
ResultSet getResultSet ()
1.0
Yes
 
ResultSetMetaData getMetaData ()
2.0 Core
Yes
 
short getShort (int)
1.0
Yes
 
short getShort (String)
3.0
No
Throws "unsupported method" exception.
SQLWarning getWarnings ()
1.0
Yes
 
String getString (int)
1.0
Yes
 
String getString (String)
3.0
No
Throws "unsupported method" exception.
Time getTime (int)
1.0
Yes
 
Time getTime (int, Calendar)
2.0 Core
Yes
 
Time getTime (String)
3.0
No
Throws "unsupported method" exception.
Time getTime (String, Calendar)
3.0
No
Throws "unsupported method" exception.
Timestamp getTimestamp (int)
1.0
Yes
 
Timestamp getTimestamp (int, Calendar)
2.0 Core
Yes
 
Timestamp getTimestamp (String)
3.0
No
Throws "unsupported method" exception.
Timestamp getTimestamp (String, Calendar)
3.0
No
Throws "unsupported method" exception.
URL getURL (int)
3.0
No
Throws "unsupported method" exception.
URL getURL (String)
3.0
No
Throws "unsupported method" exception.
void addBatch ()
2.0 Core
Yes
 
void addBatch (String)
2.0 Core
No
Throws "invalid method call" exception.
void cancel ()
1.0
Yes
Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
void clearBatch ()
2.0 Core
Yes
 
void clearParameters ()
1.0
Yes
 
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
 
void registerOutParameter (int, int)
1.0
Yes
This method should only be used against data stores supporting output or input-output parameters.
void registerOutParameter (int, int, int)
1.0
Yes
This method should only be used against data stores supporting output or input-output parameters.
void registerOutParameter (int, int, String)
2.0 Core
Yes
String/typename ignored. This method should only be used against data stores supporting output or input-output parameters.
void registerOutParameter (String, int)
3.0
No
Throws "unsupported method" exception.
void registerOutParameter (String, int, int)
3.0
No
Throws "unsupported method" exception.
void registerOutParameter (String, int, String)
3.0
No
Throws "unsupported method" exception.
void setArray (int, Array)
2.0 Core
No
Throws "unsupported method" exception.
void setAsciiStream (int, InputStream, int)
1.0
Yes
 
void setAsciiStream (String, InputStream, int)
3.0
No
Throws "unsupported method" exception.
void setBigDecimal (int, BigDecimal)
1.0
Yes
 
void setBigDecimal (String, BigDecimal)
3.0
No
Throws "unsupported method" exception.
void setBinaryStream (int, InputStream, int)
1.0
Yes
 
void setBinaryStream (String, InputStream, int)
3.0
No
Throws "unsupported method" exception.
void setBlob (int, Blob)
2.0 Core
Yes
 
void setBoolean (int, boolean)
1.0
Yes
 
void setBoolean (String, boolean)
3.0
No
Throws "unsupported method" exception.
void setByte (int, byte)
1.0
Yes
 
void setByte (String, byte)
3.0
No
Throws "unsupported method" exception.
void setBytes (int, byte [])
1.0
Yes
 
void setBytes (String, byte [])
3.0
No
Throws "unsupported method" exception.
void setCharacterStream (int, Reader, int)
2.0 Core
Yes
 
void setCharacterStream (String, Reader, int)
3.0
No
Throws "unsupported method" exception.
void setClob (int, Clob)
2.0 Core
Yes
 
void setCursorName (String)
1.0
No
Throws "unsupported method" exception.
void setDate (int, Date)
1.0
Yes
SQL Server throws "optional feature not implemented" exception.
void setDate (int, Date, Calendar)
2.0 Core
Yes
SQL Server throws "optional feature not implemented" exception.
void setDate (String, Date)
3.0
No
Throws "unsupported method" exception.
void setDate (String, Date, Calendar)
3.0
No
Throws "unsupported method" exception.
void setDouble (int, double)
1.0
Yes
 
void setDouble (String, double)
3.0
No
Throws "unsupported method" exception.
void setEscapeProcessing (boolean)
1.0
Yes
 
void setFetchDirection (int)
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
void setFetchSize (int)
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
void setFloat (int, float)
1.0
Yes
 
void setFloat (String, float)
3.0
No
Throws "unsupported method" exception.
void setInt (int, int)
1.0
Yes
 
void setInt (String, int)
3.0
No
Throws "unsupported method" exception.
void setLong (int, long)
1.0
Yes
SQL Server throws "optional feature not implemented" exception. However, you can use the workaround MSSMapLongToDecimal, which maps setLong to DECIMAL instead of BIGINT.
void setLong (String, long)
3.0
No
Throws "unsupported method" exception.
void setMaxFieldSize (int)
1.0
Yes
 
void setMaxRows (int)
1.0
Yes
 
void setNull (int, int)
1.0
Yes
 
void setNull (int, int, String)
2.0 Core
Yes
SequeLink does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType).
void setNull (String, int)
3.0
No
Throws "unsupported method" exception.
void setNull (String, int, String)
3.0
No
Throws "unsupported method" exception.
void setObject (int, Object)
1.0
Yes
 
void setObject (int, Object, int)
1.0
Yes
 
void setObject (int, Object, int, int)
1.0
Yes
 
void setObject (String, Object)
3.0
No
Throws "unsupported method" exception.
void setObject (String, Object, int)
3.0
No
Throws "unsupported method" exception.
void setObject (String, Object, int, int)
3.0
No
Throws "unsupported method" exception.
void setQueryTimeout (int)
1.0
Yes
Not supported on DB2 z/OS servers. Support for the JDBC and ODBC Socket Servers is dependent on the driver it loads.
void setRef (int, Ref)
2.0 Core
No
Throws "unsupported method" exception.
void setShort (int, short)
1.0
Yes
 
void setShort (String, short)
3.0
No
Throws "unsupported method" exception.
void setString (int, String)
1.0
Yes
 
void setString (String, String)
3.0
No
Throws "unsupported method" exception.
void setTime (int, Time)
1.0
Yes
SQLServer throws "optional feature not implemented" exception.
void setTime (int, Time, Calendar)
2.0 Core
Yes
SQLServer throws "optional feature not implemented" exception.
void setTime (String, Time)
3.0
No
Throws "unsupported method" exception.
void setTime (String, Time, Calendar)
3.0
No
Throws "unsupported method" exception.
void setTimestamp (int, Timestamp)
1.0
Yes
 
void setTimestamp (int, Timestamp, Calendar)
2.0 Core
Yes
 
void setTimestamp (String, Timestamp)
3.0
No
Throws "unsupported method" exception.
void setTimestamp (String, Timestamp, Calendar)
3.0
No
Throws "unsupported method" exception.
void setUnicodeStream (int, InputStream, int)
1.0
Yes
Supported by SequeLink. This method has been deprecated in the JDBC 2.0 specification.
void setURL (int, URL)
3.0
No
Throws "unsupported method" exception.
void setURL (String, URL)
3.0
No
Throws "unsupported method" exception.

Clob Object

Clob Object 
Methods
Version
Introduced
Supported
Comments
InputStream getAsciiStream ()
2.0 Core
Yes
 
Reader getCharacterStream ()
2.0 Core
Yes
 
String getSubString (long, int)
2.0 Core
Yes
 
long length ()
2.0 Core
Yes
 
long position (Clob, long)
2.0 Core
Yes
 
long position (String, long)
2.0 Core
Yes
 
OutputStream setAsciiStream (long)
3.0 Core
Yes
 
Writer setCharacterStream (long)
3.0 Core
Yes
 
int setString (long, String)
3.0 Core
Yes
 
int setString (long, String, int, int)
3.0 Core
Yes
 
void truncate (long)
3.0 Core
Yes
 
NOTE: Clob support is emulated using LONGVARCHAR datatypes on SQL Server, Sybase, JDBC Socket, and ODBC Socket. Using emulated Clobs incurs a performance and scalability penalty.

Connection Object

Connection Object  
Methods
Version
Introduced
Supported
Comments
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
When a connection is closed while there is an active transaction, that transaction is rolled-back.
void commit ()
1.0
Yes
 
SQLWarning getWarnings ()
1.0
Yes
 
Statement createStatement ()
1.0
Yes
 
Statement createStatement (int, int)
2.0 Core
Yes
The supported values for resultSetConcurrency depend on the data store you are connected to.
Statement createStatement (int, int, int)
3.0
No
SequeLink only supports fixed Holdability values per RDBMS
boolean getAutoCommit ()
1.0
Yes
 
String getCatalog ()
1.0
Yes
Support is database-specific.
int getHoldability ()
3.0
Yes
SequeLink only supports fixed Holdability values per RDBMS
DatabaseMetaData getMetaData ()
1.0
Yes
 
int getTransactionIsolation ()
1.0
Yes
 
Map getTypeMap ()
2.0 Core
Yes
Always returns empty java.util.HashMap.
SQLWarning getWarnings ()
1.0
Yes
 
boolean isClosed ()
1.0
Yes
 
boolean isReadOnly ()
1.0
Yes
 
String nativeSQL (String)
1.0
Yes
Always returns same String as passed in.
CallableStatement prepareCall (String)
1.0
Yes
 
CallableStatement prepareCall (String, int, int)
2.0 Core
Yes
The supported values for resultSetConcurrency depend on the data store you are connected to.
CallableStatement prepareCall (String, int, int, int)
3.0
No
SequeLink only supports fixed Holdability values per RDBMS
PreparedStatement prepareStatement (String)
1.0
Yes
 
PreparedStatement prepareStatement (String, int)
3.0
No
Throws "unsupported method" exception.
PreparedStatement prepareStatement (String, int[])
3.0
No
Throws "unsupported method" exception.
PreparedStatement prepareStatement (String, int, int)
2.0 Core
Yes
The supported values for resultSetType and resultSetConcurrency depend on the data store you are connected to.
PreparedStatement prepareStatement (String, int, int, int)
3.0
No
SequeLink only supports fixed Holdability values per RDBMS
PreparedStatement prepareStatement (String, String [])
3.0
No
Throws "unsupported method" exception.
void releaseSavepoint (Savepoint)
3.0
Yes
 
void rollback ()
1.0
Yes
 
void rollback (Savepoint)
3.0
Yes
 
void setAutoCommit (boolean)
1.0
Yes
 
void setCatalog (String)
1.0
Yes
Switching of catalogs is supported if the SequeLink Server supports it.
void setHoldability (int)
3.0
No
SequeLink only supports fixed Holdability values per RDBMS.
void setReadOnly (boolean)
1.0
Yes
 
void setSavepoint ()
3.0
Yes
Not supported with Informix servers.
void setSavepoint (String)
3.0
Yes
Not supported with Informix servers.
void setTransactionIsolation (int)
1.0
Yes
 
void setTypeMap (Map)
2.0 Core
Yes
Ignored.

ConnectionPoolDataSource Object

ConnectionPoolData
Source Object  
Methods
Version
Introduced
Supported
Comments
PrintWriter getLogWriter ()
2.0 Optional
Yes
int getLoginTimeout ()
2.0 Optional
Yes
PooledConnection getPooledConnection ()
2.0 Optional
Yes
PooledConnection getPooledConnection (String, String)
2.0 Optional
Yes
void setLogWriter (PrintWriter)
2.0 Optional
Yes
void setLoginTimeout (int)
2.0 Optional
Yes

DatabaseMetaData Object

DatabaseMetaData Object  
Methods
Version
Introduced
Supported
Comments
boolean allProceduresAreCallable ()
1.0
Yes
 
boolean allTablesAreSelectable ()
1.0
Yes
 
boolean dataDefinitionCausesTransaction
Commit ()
1.0
Yes
 
boolean dataDefinitionIgnoredInTransactions ()
1.0
Yes
 
boolean deletesAreDetected (int)
2.0 Core
Yes
 
boolean doesMaxRowSizeIncludeBlobs ()
1.0
Yes
Not supported with DB2, SQL Server, and Sybase servers.
ResultSet getAttributes (String, String)
3.0
No
Always returns empty result set.
ResultSet getBestRowIdentifier (String, String, String, int, boolean)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
ResultSet getCatalogs ()
1.0
Yes
This method is supported if the SequeLink Server supports it.
String getCatalogSeparator ()
1.0
Yes
 
String getCatalogTerm ()
1.0
Yes
 
ResultSet getColumnPrivileges (String, String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
ResultSet getColumns (String, String, String, String)
1.0
Yes
 
ResultSet getColumns (String, String, String, String)
3.0 Extension
Yes
The extended resultset columns will all contain null as values.
Connection getConnection ()
2.0 Core
Yes
ResultSet getCrossReference (String, String, String, String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
int getDatabaseMajorVersion ()
3.0
Yes
 
int getDatabaseMinorVersion ()
3.0
Yes
 
String getDatabaseProductName ()
1.0
Yes
 
String getDatabaseProductVersion ()
1.0
Yes
 
int getDefaultTransactionIsolation ()
1.0
Yes
 
int getDriverMajorVersion ()
1.0
Yes
 
int getDriverMinorVersion ()
1.0
Yes
 
String getDriverName ()
1.0
Yes
 
String getDriverVersion ()
1.0
Yes
 
ResultSet getExportedKeys (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
String getExtraNameCharacters ()
1.0
Yes
 
String getIdentifierQuoteString ()
1.0
Yes
 
ResultSet getImportedKeys (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
ResultSet getIndexInfo (String, String, String, boolean, boolean)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
int getJDBCMajorVersion ()
3.0
Yes
 
int getJDBCMinorVersion ()
3.0
Yes
 
int getMaxBinaryLiteralLength ()
1.0
Yes
 
int getMaxCatalogNameLength ()
1.0
Yes
 
int getMaxCharLiteralLength ()
1.0
Yes
 
int getMaxColumnNameLength ()
1.0
Yes
 
int getMaxColumnsInGroupBy ()
1.0
Yes
 
int getMaxColumnsInIndex ()
1.0
Yes
 
int getMaxColumnsInOrderBy ()
1.0
Yes
 
int getMaxColumnsInSelect ()
1.0
Yes
 
int getMaxColumnsInTable ()
1.0
Yes
 
int getMaxConnections ()
1.0
Yes
 
int getMaxCursorNameLength ()
1.0
Yes
 
int getMaxIndexLength ()
1.0
Yes
 
int getMaxProcedureNameLength ()
1.0
Yes
 
int getMaxRowSize ()
1.0
Yes
 
int getMaxSchemaNameLength ()
1.0
Yes
 
int getMaxStatementLength ()
1.0
Yes
 
int getMaxStatements ()
1.0
Yes
 
int getMaxTableNameLength ()
1.0
Yes
 
int getMaxTablesInSelect ()
1.0
Yes
 
int getMaxUserNameLength ()
1.0
Yes
 
String getNumericFunctions ()
1.0
Yes
 
ResultSet getPrimaryKeys (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
ResultSet getProcedureColumns (String, String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
String getProcedureTerm ()
1.0
Yes
 
ResultSet getProcedures (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
int getResultSetHoldability ()
3.0
Yes
 
ResultSet getSchemas ()
1.0
Yes
The JDBC driver supports this method if the data store has support for it.
ResultSet getSchemas ()
3.0 Extension
Yes
The JDBC driver supports this method if the data store has support for it.
String getSchemaTerm ()
1.0
Yes
 
String getSearchStringEscape ()
1.0
Yes
 
String getStringFunctions ()
1.0
Yes
 
String getSQLKeywords ()
1.0
Yes
 
int getSQLStateType ()
3.0
Yes
 
String getSystemFunctions ()
1.0
Yes
 
ResultSet getSuperTables (String, String, String)
3.0
No
Always returns empty ResultSet.
ResultSet getSuperTypes (String, String, String)
3.0
No
Always returns empty ResultSet.
ResultSet getTablePrivileges (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store supports it.
ResultSet getTableTypes ()
1.0
Yes
 
ResultSet getTables (String, String, String, String [])
1.0
Yes
 
ResultSet getTables (String, String, String, String [])
3.0 Extension
Yes
The extended resultset columns will all contain null as values.
String getTimeDateFunctions ()
1.0
Yes
 
ResultSet getTypeInfo ()
1.0
Yes
 
ResultSet getUDTs (String, String, String,
int [])
2.0 Core
No
SequeLink does not support the Advanced Data Type functionality and always returns an empty result set.
ResultSet getUDTs (String, String, String,
int [])
3.0 Extension
No
SequeLink does not support the Advanced Data Type functionality and always returns an empty result set.
String getURL ()
1.0
Yes
String getUserName ()
1.0
Yes
ResultSet getVersionColumns (String, String, String)
1.0
Yes
The JDBC driver supports this method if the data store supports it.
boolean insertsAreDetected (int)
2.0 Core
Yes
 
boolean isCatalogAtStart ()
1.0
Yes
 
boolean isReadOnly ()
1.0
Yes
 
boolean locatorsUpdateCopy ()
3.0
Yes
 
boolean nullPlusNonNullIsNull ()
1.0
Yes
 
boolean nullsAreSortedAtEnd ()
1.0
Yes
 
boolean nullsAreSortedAtStart ()
1.0
Yes
 
boolean nullsAreSortedHigh ()
1.0
Yes
 
boolean nullsAreSortedLow ()
1.0
Yes
 
boolean othersDeletesAreVisible (int)
2.0 Core
Yes
 
boolean othersInsertsAreVisible (int)
2.0 Core
Yes
 
boolean othersUpdatesAreVisible (int)
2.0 Core
Yes
 
boolean ownDeletesAreVisible (int)
2.0 Core
Yes
 
boolean ownInsertsAreVisible (int)
2.0 Core
Yes
 
boolean ownUpdatesAreVisible (int)
2.0 Core
Yes
 
boolean storesLowerCaseIdentifiers ()
1.0
Yes
 
boolean storesLowerCaseQuoted
Identifiers ()
1.0
Yes
 
boolean storesMixedCaseIdentifiers ()
1.0
Yes
 
boolean storesMixedCaseQuoted
Identifiers ()
1.0
Yes
 
boolean storesUpperCaseIdentifiers ()
1.0
Yes
 
boolean supportsResultSetHoldability (int)
3.0
Yes
 
boolean supportsAlterTableWith
AddColumn ()
1.0
Yes
 
boolean supportsAlterTableWith
DropColumn ()
1.0
Yes
 
boolean supportsANSI92EntryLevelSQL ()
1.0
Yes
 
boolean supportsANSI92FullSQL ()
1.0
Yes
 
boolean supportsANSI92Intermediate
SQL ()
1.0
Yes
 
boolean supportsBatchUpdates ()
2.0 Core
Yes
 
boolean supportsCatalogsInData
Manipulation ()
1.0
Yes
 
boolean supportsCatalogsInIndex ()
1.0
Yes
 
boolean supportsCatalogsInPrivilege
Definitions ()
1.0
Yes
 
boolean supportsCatalogsInProcedure
Calls ()
1.0
Yes
 
boolean supportsCatalogsInTable
Definitions ()
1.0
Yes
 
boolean supportsColumnAliasing ()
1.0
Yes
 
boolean supportsConvert ()
1.0
Yes
 
boolean supportsConvert (int, int)
1.0
Yes
 
boolean supportsCoreSQLGrammar ()
1.0
Yes
 
boolean supportsCorrelatedSubqueries ()
1.0
Yes
 
boolean supportsDataDefinitionAndData
ManipulationTransactions ()
1.0
Yes
 
boolean supportsDataManipulation
TransactionsOnly ()
1.0
Yes
 
boolean supportsDifferentTableCorrelation
Names ()
1.0
Yes
 
boolean supportsExpressionsIn
OrderBy ()
1.0
Yes
 
boolean supportsExtendedSQLGrammar ()
1.0
Yes
 
boolean supportsFullOuterJoins ()
1.0
Yes
 
boolean supportsGetGeneratedKeys ()
3.0
Yes
 
boolean supportsGroupBy ()
1.0
Yes
 
boolean supportsGroupByBeyondSelect ()
1.0
Yes
 
boolean supportsGroupByUnrelated ()
1.0
Yes
 
boolean supportsIntegrityEnhancement
Facility ()
1.0
Yes
 
boolean supportsLikeEscapeClause ()
1.0
Yes
 
boolean supportsLimitedOuterJoins ()
1.0
Yes
 
boolean supportsMinimumSQLGrammar ()
1.0
Yes
 
boolean supportsMixedCaseIdentifiers ()
1.0
Yes
 
boolean supportsMixedCaseQuoted
Identifiers ()
1.0
Yes
 
boolean supportsMultipleOpenResultSets ()
3.0
Yes
 
boolean supportsMultipleResultSets ()
1.0
Yes
Not supported on Informix.
NOTE: Use of this method with large result sets incurs a performance and scalability penalty.
boolean supportsMultipleTransactions ()
1.0
Yes
 
boolean supportsNamedParameters ()
3.0
Yes
 
boolean supportsNonNullableColumns ()
1.0
Yes
 
boolean supportsOpenCursorsAcross
Commit ()
1.0
Yes
 
boolean supportsOpenCursorsAcross
Rollback ()
1.0
Yes
 
boolean supportsOpenStatementsAcross
Commit ()
1.0
Yes
 
boolean supportsOpenStatementsAcross
Rollback ()
1.0
Yes
 
boolean supportsOrderByUnrelated ()
1.0
Yes
 
boolean supportsOuterJoins ()
1.0
Yes
 
boolean supportsPositionedDelete ()
1.0
Yes
The driver returns hard coded false.
boolean supportsPositionedUpdate ()
1.0
Yes
The driver returns hard coded false.
boolean supportsResultSetConcurrency (int, int)
2.0 Core
Yes
 
boolean supportsResultSetType (int)
2.0 Core
Yes
 
boolean supportsSavePoints ()
3.0
Yes
 
boolean supportsSchemasInData
Manipulation ()
1.0
Yes
 
boolean supportsSchemasInIndex
Definitions ()
1.0
Yes
 
boolean supportsSchemasIn
PrivilegeDefinitions ()
1.0
Yes
 
boolean supportsSchemasInProcedure
Calls ()
1.0
Yes
 
boolean supportsSchemasInTable
Definitions ()
1.0
Yes
 
boolean supportsSelectForUpdate ()
1.0
Yes
SequeLink supports SELECT FOR UPDATE statements against certain DBMSs. SequeLink returns false, as it does not support UPDATE WHERE CURRENT OF statements.
boolean supportsStoredProcedures ()
1.0
Yes
 
boolean supportsSubqueriesIn
Comparisons ()
1.0
Yes
 
boolean supportsSubqueriesInExists ()
1.0
Yes
 
boolean supportsSubqueriesInIns ()
1.0
Yes
 
boolean supportsSubqueriesIn
Quantifieds ()
1.0
Yes
 
boolean supportsTableCorrelationNames ()
1.0
Yes
 
boolean supportsTransactionIsolationLevel (int)
1.0
Yes
 
boolean supportsTransactions ()
1.0
Yes
 
boolean supportsUnion ()
1.0
Yes
 
boolean supportsUnionAll ()
1.0
Yes
 
boolean updatesAreDetected (int)
2.0 Core
Yes
 
boolean usesLocalFilePerTable ()
1.0
Yes
 
boolean usesLocalFiles ()
1.0
Yes
 

DataSource Object

DataSource Object  
Methods
Version
Introduced
Supported
Comments
Connection getConnection ()
2.0 Optional
Yes
 
Connection getConnection (String, String)
2.0 Optional
Yes
  
PrintWriter getLogWriter ()
2.0 Optional
Yes
 
int getLoginTimeout ()
2.0 Optional
Yes
 
void setLogWriter (PrintWriter)
2.0 Optional
Yes
Enables DataDirect Spy, which traces JDBC information into the specified PrintWriter.
void setLoginTimeout (int)
2.0 Optional
Yes

Driver Object

Driver Object  
Methods
Version
Introduced
Supported
Comments
boolean acceptsURL (String)
1.0
Yes
 
Connection connect (String, Properties)
1.0
Yes
 
int getMajorVersion ()
1.0
Yes
 
int getMinorVersion ()
1.0
Yes
 
DriverPropertyInfo [] getPropertyInfo (String, Properties)
1.0
Yes
 
boolean jdbcCompliant ()
1.0
Yes
 

ParameterMetaData Object

ParameterMetaData Object  
Methods
Version
Introduced
Supported
Comments
String getParameterClassName (int)
3.0
Yes
 
int getParameterCount ()
3.0
Yes
 
int getParameterMode (int)
3.0
Yes
 
int getParameterType (int)
3.0
Yes
 
String getParameterTypeName (int)
3.0
Yes
 
int getPrecision (int)
3.0
Yes
 
int getScale (int)
3.0
Yes
 
int isNullable (int)
3.0
Yes
 
boolean isSigned (int)
3.0
Yes
 

PooledConnection Object

PooledConnection Object
 
Methods
Version
Introduced
Supported
Comments
void addConnectionEventListener (ConnectionEventListener)
2.0 Optional
Yes
 
void close()
2.0 Optional
Yes
 
Connection getConnection()
2.0 Optional
Yes
A pooled connection object can have only one Connection object open (the one most recently created). The purpose of allowing the server (PoolManager implementation) to invoke the method getConnection a second time is to give that application server a way to take a connection away from an application and give it to another user (a rare occurrence). The drivers do not support this "reclaiming" of connections and will throw a SQLException "Reclaim of open connection is not supported."
void removeConnectionEvent
Listener (ConnectionEventListener)
2.0 Optional
Yes
 

PreparedStatement Object

PreparedStatement Object  
Methods
Version
Introduced
Supported
Comments
void addBatch ()
2.0 Core
Yes
 
void addBatch (String)
2.0 Core
No
Throws "invalid method call" exception.
void cancel ()
1.0
Yes
Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
void clearBatch ()
2.0 Core
Yes
 
void clearParameters ()
1.0
Yes
 
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
 
boolean execute ()
1.0
Yes
 
boolean execute (String)
1.0
No
Throws "invalid method call" exception.
boolean execute (String, int)
3.0
No
Throws "invalid method call" exception.
boolean execute (String, int [])
3.0
No
Throws "invalid method call" exception.
boolean execute (String, String [])
3.0
No
Throws "invalid method call" exception.
int [] executeBatch ()
2.0 Core
Yes
 
ResultSet executeQuery ()
1.0
Yes
 
ResultSet executeQuery (String)
1.0
No
Throws "invalid method call" exception.
int executeUpdate ()
1.0
Yes
 
int executeUpdate (String)
1.0
No
Throws "invalid method call" exception.
int executeUpdate (String, int)
3.0
No
Throws "unsupported method" exception.
int executeUpdate (String, int [])
3.0
No
Throws "unsupported method" exception.
int executeUpdate (String, String [])
3.0
No
Throws "unsupported method" exception.
Connection getConnection ()
2.0 Core
Yes
 
int getFetchDirection ()
2.0 Core
Yes
 
int getFetchSize ()
2.0 Core
Yes
 
ParameterMetaData getParameterMetaData()
3.0
Yes
Not supported on Oracle or Informix Servers.
ResultSet getGeneratedKeys ()
3.0
No
Throws "unsupported method" exception.
int getMaxFieldSize ()
1.0
Yes
 
int getMaxRows ()
1.0
Yes
 
ResultSetMetaData getMetaData ()
2.0 Core
Yes
 
boolean getMoreResults ()
1.0
Yes
 
boolean getMoreResults (int)
3.0
Yes
 
int getQueryTimeout ()
1.0
Yes
 
ResultSet getResultSet ()
1.0
Yes
 
int getResultSetConcurrency ()
2.0 Core
Yes
 
int getResultSetHoldability ()
3.0
No
Throws "unsupported method" exception.
int getResultSetType ()
2.0 Core
Yes
 
int getUpdateCount ()
1.0
Yes
 
SQLWarning getWarnings ()
1.0
Yes
 
void setArray (int, Array)
2.0 Core
No
Throws "unsupported method" exception.
void setAsciiStream (int, InputStream, int)
1.0
Yes
 
void setBigDecimal (int, BigDecimal)
1.0
Yes
 
void setBinaryStream (int, InputStream, int)
1.0
Yes
 
void setBlob (int, Blob)
2.0 Core
Yes
 
void setBoolean (int, boolean)
1.0
Yes
 
void setByte (int, byte)
1.0
Yes
 
void setBytes (int, byte [])
1.0
Yes
 
void setCharacterStream (int, Reader, int)
2.0 Core
Yes
 
void setClob (int, Clob)
2.0 Core
Yes
 
void setCursorName (String)
1.0
No
 
void setDate (int, Date)
1.0
Yes
SQL Server throws "optional feature not implemented" exception.
void setDate (int, Date, Calendar)
2.0 Core
Yes
SQL Server throws "optional feature not implemented" exception.
void setDouble (int, double)
1.0
Yes
 
void setEscapeProcessing (boolean)
1.0
Yes
Ignored.
void setFetchDirection (int)
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
void setFetchSize (int)
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
void setFloat (int, float)
1.0
Yes
 
void setInt (int, int)
1.0
Yes
 
void setLong (int, long)
1.0
Yes
 
void setMaxFieldSize (int)
1.0
Yes
 
void setMaxRows (int)
1.0
Yes
 
void setNull (int, int)
1.0
Yes
 
void setNull (int, int, String)
2.0 Core
Yes
SequeLink does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType).
void setObject (int, Object)
1.0
Yes
 
void setObject (int, Object, int)
1.0
Yes
 
void setObject (int, Object, int, int)
1.0
Yes
 
void setQueryTimeout (int)
1.0
Yes
Support for the JDBC and ODBC Socket Servers is dependent on the driver it loads.
void setRef (int, Ref)
2.0 Core
No
Throws "unsupported method" exception.
void setShort (int, short)
1.0
Yes
 
void setString (int, String)
1.0
Yes
 
void setTime (int, Time)
1.0
Yes
SQL Server throws "optional feature not implemented" exception.
void setTime (int, Time, Calendar)
2.0 Core
Yes
SQL Server throws "optional feature not implemented" exception.
void setTimestamp (int, Timestamp)
1.0
Yes
 
void setTimestamp (int, Timestamp, Calendar)
2.0 Core
Yes
 
void setUnicodeStream (int, InputStream, int)
1.0
Yes
Throws "unsupported method" exception. This method was deprecated in the JDBC 2.0 specification.
void setURL (int, URL)
3.0
No
Throws "unsupported method" exception.
boolean wasNull ()
1.0
Yes
 

Ref Object

Ref Object  
Methods
Version
Introduced
Supported
Comments
(all)
2.0 Core
No
Ref objects are neither exposed, nor taken as input.

Referenceable Object

Referenceable Object
 
Methods
JDBC
Version
Introduced
Supported
Comments
Reference getReference()
javax.naming
Yes
Implemented by SequeLinkDataSource.

ResultSet Object

ResultSet Object  
Methods
Version
Introduced
Supported
Comments
boolean absolute (int)
2.0 Core
Yes
 
void afterLast ()
2.0 Core
Yes
 
void beforeFirst ()
2.0 Core
Yes
 
void cancelRowUpdates ()
2.0 Core
Yes
 
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
 
void deleteRow ()
2.0 Core
Yes
 
int findColumn (String)
1.0
Yes
 
boolean first ()
2.0 Core
Yes
 
Array getArray (int)
2.0 Core
No
Throws "unsupported method" exception.
Array getArray (String)
2.0 Core
No
Throws "unsupported method" exception.
InputStream getAsciiStream (int)
1.0
Yes
For the implementation of getAsciiStream (), the driver assumes that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the driver returns bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the driver converts the binary data to the hexadecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
InputStream getAsciiStream (String)
1.0
Yes
For the implementation of getAsciiStream (), the drivers assume that the underlying data in the database only contains 7-bit ASCII characters (represented in an ASCII or EBCDIC code-page). If the assumption is true, the drivers return bytes corresponding to ASCII characters, otherwise the results are unpredictable. In the case that getAsciiStream () is called on a binary column, the driver converts the binary data to the hexidecimal representation and returns the ASCII representation. For example, the binary value 20 is represented in hexidecimal as 14 or "1" "4". In ASCII, 1 is represented by "49" and 4 is represented by "52". This implies that the ASCII stream "4952" is returned.
BigDecimal getBigDecimal (int)
2.0 Core
Yes
 
BigDecimal getBigDecimal (String)
2.0 Core
Yes
 
BigDecimal getBigDecimal (int, int)
1.0
Yes
 
BigDecimal getBigDecimal (String, int)
1.0
Yes
 
InputStream getBinaryStream (int)
1.0
Yes
 
InputStream getBinaryStream (String)
1.0
Yes
 
Blob getBlob (int)
2.0 Core
Yes
 
Blob getBlob (String)
2.0 Core
Yes
 
boolean getBoolean (int)
1.0
Yes
 
boolean getBoolean (String)
1.0
Yes
 
byte getByte (int)
1.0
Yes
 
byte getByte (String)
1.0
Yes
 
byte [] getBytes (int)
1.0
Yes
 
byte [] getBytes (String)
1.0
Yes
 
Reader getCharacterStream (int)
2.0 Core
Yes
 
Reader getCharacterStream (String)
2.0 Core
Yes
 
Clob getClob (int)
2.0 Core
Yes
 
Clob getClob (String)
2.0 Core
Yes
 
int getConcurrency ()
2.0 Core
Yes
 
String getCursorName ()
1.0
No
Throws "unsupported method" exception.
Date getDate (int)
1.0
Yes
 
Date getDate (String)
1.0
Yes
 
Date getDate (int, Calendar)
2.0 Core
Yes
 
Date getDate (String, Calendar)
2.0 Core
Yes
 
double getDouble (int)
1.0
Yes
 
double getDouble (String)
1.0
Yes
 
int getFetchDirection ()
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
int getFetchSize ()
2.0 Core
Yes
SequeLink supports this method, but will ignore this hint provided by the application.
float getFloat (int)
1.0
Yes
 
float getFloat (String)
1.0
Yes
 
int getInt (int)
1.0
Yes
 
int getInt (String)
1.0
Yes
 
long getLong (int)
1.0
Yes
 
long getLong (String)
1.0
Yes
 
ResultSetMetaData getMetaData ()
1.0
Yes
 
Object getObject (int)
1.0
Yes
 
Object getObject (String)
1.0
Yes
 
Object getObject (int, Map)
2.0 Core
Yes
Map ignored.
Object getObject (String, Map)
2.0 Core
Yes
Map ignored.
Ref getRef (int)
2.0 Core
No
Throws "unsupported method" exception.
Ref getRef (String)
2.0 Core
No
Throws "unsupported method" exception.
int getRow ()
2.0 Core
Yes
 
short getShort (int)
1.0
Yes
 
short getShort (String)
1.0
Yes
 
Statement getStatement ()
2.0 Core
Yes
 
String getString (int)
1.0
Yes
 
String getString (String)
1.0
Yes
 
Time getTime (int)
1.0
Yes
 
Time getTime (String)
1.0
Yes
 
Time getTime (int, Calendar)
2.0 Core
Yes
 
Time getTime (String, Calendar)
2.0 Core
Yes
 
Timestamp getTimestamp (int)
1.0
Yes
 
Timestamp getTimestamp (String)
1.0
Yes
 
Timestamp getTimestamp (int, Calendar)
2.0 Core
Yes
 
Timestamp getTimestamp (String, Calendar)
2.0 Core
Yes
 
int getType ()
2.0 Core
Yes
 
InputStream getUnicodeStream (int)
1.0
Yes
 
InputStream getUnicodeStream (String)
1.0
Yes
This method was deprecated in the JDBC 2.0 specification.
URL getURL (int)
3.0
No
Throws "unsupported method" exception.
URL getURL (String)
3.0
No
Throws "unsupported method" exception.
SQLWarning getWarnings ()
1.0
Yes
 
void insertRow ()
2.0 Core
Yes
 
boolean isAfterLast ()
2.0 Core
Yes
 
boolean isBeforeFirst ()
2.0 Core
Yes
 
boolean isFirst ()
2.0 Core
Yes
 
boolean isLast ()
2.0 Core
Yes
 
boolean last ()
2.0 Core
Yes
 
void moveToCurrentRow ()
2.0 Core
Yes
 
void moveToInsertRow ()
2.0 Core
Yes
 
boolean next ()
1.0
Yes
 
boolean previous ()
2.0 Core
Yes
 
void refreshRow ()
2.0 Core
Yes
 
boolean relative (int)
2.0 Core
Yes
 
boolean rowDeleted ()
2.0 Core
Yes
 
boolean rowInserted ()
2.0 Core
Yes
 
boolean rowUpdated ()
2.0 Core
Yes
 
void setFetchDirection (int)
2.0 Core
Yes
 
void setFetchSize (int)
2.0 Core
Yes
 
void updateArray (int, Array)
3.0
No
Throws "unsupported method" exception.
void updateArray (String, Array)
3.0
No
Throws "unsupported method" exception.
void updateAsciiStream (int, InputStream, int)
2.0 Core
Yes
 
void updateAsciiStream (String, InputStream, int)
2.0 Core
Yes
 
void updateBigDecimal (int, BigDecimal)
2.0 Core
Yes
 
void updateBigDecimal (String, BigDecimal)
2.0 Core
Yes
 
void updateBinaryStream (int, InputStream, int)
2.0 Core
Yes
 
void updateBinaryStream (String, InputStream, int)
2.0 Core
Yes
 
void updateBlob (int, Blob)
3.0
Yes
 
void updateBlob (String, Blob)
3.0
Yes
 
void updateBoolean (int, boolean)
2.0 Core
Yes
 
void updateBoolean (String, boolean)
2.0 Core
Yes
 
void updateByte (int, byte)
2.0 Core
Yes
 
void updateByte (String, byte)
2.0 Core
Yes
 
void updateBytes (int, byte [])
2.0 Core
Yes
 
void updateBytes (String, byte [])
2.0 Core
Yes
 
void updateCharacterStream (int, Reader, int)
2.0 Core
Yes
 
void updateCharacterStream (String, Reader, int)
2.0 Core
Yes
 
void updateClob (int, Clob)
3.0
No
 
void updateClob (String, Clob)
3.0
No
 
void updateDate (int, Date)
2.0 Core
Yes
 
void updateDate (String, Date)
2.0 Core
Yes
 
void updateDouble (int, double)
2.0 Core
Yes
 
void updateDouble (String, double)
2.0 Core
Yes
 
void updateFloat (int, float)
2.0 Core
Yes
 
void updateFloat (String, float)
2.0 Core
Yes
 
void updateInt (int, int)
2.0 Core
Yes
 
void updateInt (String, int)
2.0 Core
Yes
 
void updateLong (int, long)
2.0 Core
Yes
 
void updateLong (String, long)
2.0 Core
Yes
 
void updateNull (int)
2.0 Core
Yes
 
void updateNull (String)
2.0 Core
Yes
 
void updateObject (int, Object)
2.0 Core
Yes
 
void updateObject (String, Object)
2.0 Core
Yes
 
void updateObject (int, Object, int)
2.0 Core
Yes
 
void updateObject (String, Object, int)
2.0 Core
Yes
 
void updateRef (int, Ref)
3.0
No
Throws "unsupported method" exception.
void updateRef (String, Ref)
3.0
No
Throws "unsupported method" exception.
void updateRow ()
2.0 Core
Yes
 
void updateShort (int, short)
2.0 Core
Yes
 
void updateShort (String, short)
2.0 Core
Yes
 
void updateString (int, String)
2.0 Core
Yes
 
void updateString (String, String)
2.0 Core
Yes
 
void updateTime (int, Time)
2.0 Core
Yes
 
void updateTime (String, Time)
2.0 Core
Yes
 
void updateTimestamp (int, Timestamp)
2.0 Core
Yes
 
void updateTimestamp (String, Timestamp)
2.0 Core
Yes
 
boolean wasNull ()
1.0
Yes
 

ResultSetMetaData Object

ResultSetMetaData Object  
Methods
Version
Introduced
Supported
Comments
String getCatalogName (int)
1.0
Yes
The behavior of this method is data store specific.
String getColumnClassName (int)
2.0 Core
Yes
 
int getColumnCount ()
1.0
Yes
 
int getColumnDisplaySize (int)
1.0
Yes
 
String getColumnLabel (int)
1.0
Yes
 
String getColumnName (int)
1.0
Yes
 
int getColumnType (int)
1.0
Yes
 
String getColumnTypeName (int)
1.0
Yes
 
int getPrecision (int)
1.0
Yes
 
int getScale (int)
1.0
Yes
 
String getSchemaName (int)
1.0
Yes
The behavior of this method is data store specific.
String getTableName (int)
1.0
Yes
The behavior of this method is data store specific.
boolean isAutoIncrement (int)
1.0
Yes
 
boolean isCaseSensitive (int)
1.0
Yes
 
boolean isCurrency (int)
1.0
Yes
 
boolean isDefinitelyWritable (int)
1.0
Yes
 
int isNullable (int)
1.0
Yes
 
boolean isReadOnly (int)
1.0
Yes
 
boolean isSearchable (int)
1.0
Yes
 
boolean isSigned (int)
1.0
Yes
 
boolean isWritable (int)
1.0
Yes
 

RowSet Object

RowSet Object  
Methods
Version
Introduced
Supported
Comments
(all)
2.0 Optional
No
 

SavePoint Object

SavePoint Object  
Methods
Version
Introduced
Supported
Comments
int getSavepointId ()
3.0
Yes
Savepoint not supported on Informix, JDBC Socket, and ODBC Socket Server servers.
String getSavepointName ()
3.0
Yes
Savepoint not supported on Informix, JDBC Socket, and ODBC Socket Server servers.

Serializable Object

Serializable Object  
Methods
Version
Introduced
Supported
Comments
(N/A)
java.io
Yes
Implemented by SequeLinkDataSource.

Statement Object

Statement Object  
Methods
Version
Introduced
Supported
Comments
void addBatch (String)
2.0 Core
Yes
 
void cancel ()
1.0
Yes
Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
void clearBatch ()
2.0 Core
Yes
 
void clearWarnings ()
1.0
Yes
 
void close ()
1.0
Yes
 
boolean execute (String)
1.0
Yes
 
boolean execute (String, int)
3.0
No
Throws "unsupported method" exception.
boolean execute (String, int [])
3.0
No
Throws "unsupported method" exception.
boolean execute (String, String [])
3.0
No
Throws "unsupported method" exception.
int [] executeBatch ()
2.0 Core
Yes
 
ResultSet executeQuery (String)
1.0
Yes
 
int executeUpdate (String)
1.0
Yes
 
int executeUpdate (String, int)
3.0
No
Throws "unsupported method" exception.
int executeUpdate (String, int [])
3.0
No
Throws "unsupported method" exception.
int executeUpdate (String, String [])
3.0
No
Throws "unsupported method" exception.
Connection getConnection ()
2.0 Core
Yes
 
int getFetchDirection ()
2.0 Core
Yes
SequeLink supports this method, but ignores this hint provided by the application.
int getFetchSize ()
2.0 Core
Yes
SequeLink supports this method, but ignores this hint provided by the application.
ResultSet getGeneratedKeys ()
3.0
No
Throws "unsupported method" exception.
int getMaxFieldSize ()
1.0
Yes
 
int getMaxRows ()
1.0
Yes
 
boolean getMoreResults ()
1.0
Yes
 
boolean getMoreResults (int)
3.0
No
Throws "unsupported method" exception.
int getQueryTimeout ()
1.0
Yes
Returns 0 for DB2 UDB and Informix.
ResultSet getResultSet ()
1.0
Yes
 
int getResultSetConcurrency ()
2.0 Core
Yes
 
int getResultSetHoldability ()
3.0
No
Throws "unsupported method" exception.
int getResultSetType ()
2.0 Core
Yes
 
int getUpdateCount ()
1.0
Yes
 
SQLWarning getWarnings ()
1.0
Yes
 
void setCursorName (String)
1.0
No
 
void setEscapeProcessing (boolean)
1.0
Yes
 
void setFetchDirection (int)
2.0 Core
Yes
 
void setFetchSize (int)
2.0 Core
Yes
 
void setMaxFieldSize (int)
1.0
Yes
 
void setMaxRows (int)
1.0
Yes
 
void setQueryTimeout (int)
1.0
Yes
Support for JDBC and ODBC Socket Servers is dependent on the driver it loads.

Struct Object

Struct Object  
Methods
Version
Introduced
Supported
Comments
(all)
2.0
No
Struct objects are neither exposed, nor taken as input.

XAConnection Object

XAConnection Object  
Methods
Version
Introduced
Supported
Comments
XAResource getXAResource()
2.0 Optional
Yes
 

XADataSource Object

XADataSource Object  
Methods
Version
Introduced
Supported
Comments
int getLoginTimeout ()
2.0 Optional
Yes
 
PrintWriter getLogWriter ()
2.0 Optional
Yes
 
XAConnection getXAConnection ()
2.0 Optional
Yes
The behavior of these methods depends on whether distributed/XA transactions are supported by the SequeLink Server. If not supported, the JDBC driver will throw an "XA-Open failed with return code -3" exception.
XAConnection getXAConnection (String, String)
2.0 Optional
Yes
The behavior of these methods depends on whether distributed/XA transactions are supported by the SequeLink Server. If not supported, the JDBC driver will throw an "XA-Open failed with return code -3" exception.
void setLoginTimeout (int)
2.0 Optional
Yes
 
void setLogWriter (PrintWriter)
2.0 Optional
Yes